﻿<local:DocumentBase x:Class="WPFExcelReport.JLTHLSTA"
           xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
          xmlns:local="clr-namespace:ReflectionStudio.Components.UserControls;assembly=ReflectionStudio.Core"
                xmlns:fd="clr-namespace:Labs.Filtering;assembly=ReflectionStudio.Core"
        xmlns:wep="clr-namespace:WPFExcelReport"
       Height="700" Width="1024" 
       Background="White" 
         Loaded="Window_Loaded"
        Title="JLTHLSTA"  
     >
    <local:DocumentBase.Resources>
    </local:DocumentBase.Resources>
    <Grid DataContext="{Binding}" Width="1021">
        <Grid.RowDefinitions>
            <RowDefinition Height="100" />
            <RowDefinition Height="150*" />
            <RowDefinition Height="200*" />
            <RowDefinition Height="50*" />
        </Grid.RowDefinitions>
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width="512*"></ColumnDefinition>
            <ColumnDefinition Width="463*"></ColumnDefinition>
            <ColumnDefinition Width="49*" />
        </Grid.ColumnDefinitions>
        <StackPanel Margin="0,0,19,0" Grid.RowSpan="4" Grid.ColumnSpan="2">
            <WrapPanel Width="950">
                <Label Content="生产交期从" Height="26" HorizontalAlignment="Left" Margin="10,5,0,0" Name="label1" VerticalAlignment="Top" Width="86" FontSize="16" />
                <DatePicker Height="25" HorizontalAlignment="Left" Margin="0,2,0,0" Name="FROM_DN_DATE" VerticalAlignment="Top" Panel.ZIndex="1"
                                    SelectedDateChanged ="FROM_DN_DATE_SelectedDateChanged" Width="113" />
                <Label Content="至" Height="28" HorizontalAlignment="Left" Margin="10,5,0,0" Name="label2" VerticalAlignment="Top" Width="19" FontSize="16" />
                <DatePicker Height="25" HorizontalAlignment="Left" Margin="0,2,0,0" Name="END_DN_DATE" VerticalAlignment="Top" Panel.ZIndex="2"
                                    SelectedDateChanged ="END_DN_DATE_SelectedDateChanged" Width="112" />
                <Label  Margin="10,0,0,0" Content="仅查询已输入了生产交期的订单" Height="26" Name="label5" Width="227" FontSize="16" />
            </WrapPanel>
        </StackPanel>
        <StackPanel Margin="0,35,19,0" Grid.RowSpan="4" Grid.ColumnSpan="2">
            <WrapPanel Width="950">
                <Label Content="业务员下单日期从" Height="26" HorizontalAlignment="Left" Margin="10,5,0,0" Name="label3" VerticalAlignment="Top" Width="130" FontSize="16" />
                <DatePicker Height="25" HorizontalAlignment="Left" Margin="0,2,0,0" Name="FROM_DATE" VerticalAlignment="Top" Panel.ZIndex="3"
                                    SelectedDateChanged ="FROM_DATE_SelectedDateChanged" Width="113" />
                <Label Content="至" Height="28" HorizontalAlignment="Left" Margin="10,5,0,0" Name="label4" VerticalAlignment="Top" Width="19" FontSize="16" />
                <DatePicker Height="25" HorizontalAlignment="Left" Margin="0,2,0,0" Name="END_DATE" VerticalAlignment="Top" Panel.ZIndex="4"
                                    SelectedDateChanged ="END_DATE_SelectedDateChanged" Width="112" />
                <Button Content="查询订单" Height="33" Margin="10,0,0,0"  Name="btnQuery" Width="64" Panel.ZIndex="5"
                        Click="btnQuery_Click"/>
                <Button Content="导出订单" Height="33" Margin="10,0,0,0"  Name="btnEXCEL" Width="65" Panel.ZIndex="6"
                        Click="btnEXCEL_Click"/>
            </WrapPanel>
            <WrapPanel Width="952">
                <fd:FilteringDataGrid CanUserReorderColumns="True"  
          CanUserResizeRows="True" CanUserSortColumns="True"
            IsFilteringCaseSensitive="False"
            AutoGenerateColumns="False"   
                  EnableRowVirtualization="True"  
                  Width="950"
                  Height="530" FontSize="11"
                  EnableColumnVirtualization="True"  
                  ScrollViewer.HorizontalScrollBarVisibility="Auto"
                  ScrollViewer.VerticalScrollBarVisibility="Auto"
                  RowDetailsVisibilityMode="VisibleWhenSelected" HorizontalAlignment="Stretch" VerticalAlignment="Stretch"
                               IsSynchronizedWithCurrentItem="True" Opacity="10" Visibility="Visible"
                               ItemsSource="{Binding}" x:Name="MasterDg" 
                               Grid.ColumnSpan="2" Margin="0,5,0,0" Grid.RowSpan="3" Grid.Row="1">
                    <!--STAFF	KDKNAME	NEWQTY TOTQTY	FREQTY	CREQTY	NORQTY	ONCEQTY	NORRATE	ONCERATE-->
                    <fd:FilteringDataGrid.Columns>
                        <DataGridTextColumn Binding="{Binding Path=STAFF}" Header="业务员" Width="SizeToCells" MinWidth="50" />
                        <DataGridTextColumn Binding="{Binding Path=KDKNAME}" Header="客户" Width="SizeToCells" MinWidth="60" />
                        <DataGridTextColumn Binding="{Binding Path=NEWQTY}" Header="新样只数" Width="SizeToCells" MinWidth="50" />
                        <DataGridTextColumn Binding="{Binding Path=FREQTY}" Header="工厂重打样只数" Width="SizeToCells" MinWidth="70" />
                        <DataGridTextColumn Binding="{Binding Path=CREQTY}" Header="客户重打样只数" Width="SizeToCells" MinWidth="70" />
                        <DataGridTextColumn Binding="{Binding Path=TOTQTY}" Header="累计只数" Width="SizeToCells" MinWidth="50" />
                        <DataGridTextColumn Binding="{Binding Path=NORQTY}" Header="准期只数" Width="SizeToCells" MinWidth="50" />
                        <DataGridTextColumn Binding="{Binding Path=ONCEQTY}" Header="一次成功只数" Width="SizeToCells" MinWidth="70"  />
                        <DataGridTextColumn Binding="{Binding Path=NORRATE}" Header="准期率" Width="SizeToCells" MinWidth="50" />
                        <DataGridTextColumn Binding="{Binding Path=ONCERATE}" Header="一次成功率" Width="SizeToCells" MinWidth="60" />
                        
                    </fd:FilteringDataGrid.Columns>
                </fd:FilteringDataGrid  >
            </WrapPanel>
        </StackPanel>
    </Grid>
</local:DocumentBase>
